'use strict';

module.exports = app => {
	const {INTEGER,DECIMAL,STRING}=app.Sequelize;

	const DeviceSublist=app.model.define('deviceSublist',{
		id:{type:INTEGER,primaryKey:true},
		device_id:{type:INTEGER},
		total_flow:{type:DECIMAL(12,2)},
		spent_flow:{type:DECIMAL(12,2)},
		daily_flow:{type:DECIMAL(12,2)},
		terminal_version:{type:STRING(32)},
		device_imei:{type:STRING(128)},
		mobile:{type:STRING(12)},
		is_usable:{type:INTEGER},
		is_activate:{type:INTEGER},
		is_real:{type:INTEGER},
		is_wifi:{type:INTEGER},
		is_local:{type:INTEGER},
		activate_time:{type:INTEGER},
		create_time:{type:INTEGER},
		update_time:{type:INTEGER}});
	return DeviceSublist;
};